Spataro holdings owns the RCMP station, and they were one of the developers involved with 55 Queen. I have noticed that their residential apartment buildings in Riverview have been re-branded as Rodgers Apartment Rentals. I don't know if they sold, or are just under Rodgers management.
As for a Hotel, it doesn't seem like an obvious location. It's close to Gunningsville Blvd. which would easily get you to Hillsborough Rd., then to the Rocks & Fundy as well as downtown Moncton.. There's also Moncton Golf Club but still, who picks Riverview N.B. as a vacation destination?
I wonder if some iteration of 55 Queen on a smaller scale could work? A small boutique style hotel on one floor of a larger building.
Something more creative than a stand alone hotel might stand a chance here.